This folder contains a kit with AppleScripts, templates and sample databases that shows how you can use PageSpinner to publish web pages with data from FileMaker Pro, HyperCard and 4D Server. If you are familiar with AppleScript it should be easy to customize the scripts and templates to your needs. If you haven't used AppleScript or the Script Editor included with System 7.5 before, it should still be relatively easy to modify the included AppleScripts to work with your databases.
You can learn more about how modify the AppleScripts and to publish data from databases in the file "database_publishing.html", located inside the AppleScript Documentation folder.
Please make a backup copy of this folder before you start modifying it.
It is always great to have a backup copy around if something goes wrong...
If you are using WorldScript with double-byte character input you should edit the template files and use the menu File : Set Filing Options... to set the file to be saved in the format Mac TEXT.
The following databases and example scripts are included:
FileMaker Pro
- "Products FileMaker Pro" is a small FileMaker Pro database
To use this database you will need FileMaker Pro 3.0 or later
The example scripts "Database Table Demo Script" and "Database Multi-Page Demo Script" are by default set to use FileMaker Pro. They can be changed to use HyperCard or 4D by adding and removing a few comments a few comments in the script.
To publish web pages from the example FileMaker Pro database:
Table Example:
- launch PageSpinner
- open the database named "Products FileMaker Pro" with FileMaker Pro.
- open the AppleScript "Database Table Demo Script" with Script Editor and run the script.
- the script will ask you were the files "Table_Stationery.html" and "Table_Record_Stationery.html" are located, they can be found in the same folder as this document: "Database_Publishing" in PageSpinner's Documentation folder.
Multi PageExample:
- launch PageSpinner
- open the database named "Products FileMaker Pro" with FileMaker Pro
- open the AppleScript "Database Multi-Page Demo Script" with Script Editor and run the script.
- the script will ask you were the files "Multi_Page_Record.html" and "Multi_Page_Record.html" are located, they can be found in the same folder as this document: "Database_Publishing" in PageSpinner's Documentation folder.
- the script will ask you were to save the pages generated when publishing the database, select the folder named "Multi_Page_Sample".
When modifying the script to handle your own databases you can enter the path to the folder that contains your own stationery files, so you do not have to select the files and folders every time you run the script. Additional information can be found in the file "database_publishing.html".
HyperCard
- "Products HyperCard" is a small stack with the sample database
To use this database you will need HyperCard Player 2.3.5 or later
To edit this database you will need HyperCard 2.3.5 or later
The example scripts "Database List Demo Script" is by default set to use HyperCard.
List Page Example:
To publish web pages from the example HyperCard stack:
- launch PageSpinner.
- open the stack "Products HyperCard" with HyperCard or HyperCard Player.
- open the AppleScript "Database List Demo Script" with Script Editor and run the script
- the script will ask you were the files "List_Stationery.html" and "Record_Stationery.html" are located, they can be found in the same folder as this document: "Database_Publishing" in PageSpinner's Documentation folder.
You can also edit the example scripts "Database Table Demo Script" and "Database Multi-Page Demo Script" with Script Editor to work with HyperCard by adding and removing a few comments in the script. Additional information can be found in the file "database_publishing.html".
When modifying the script to handle your own databases you can enter the path to the folder that contains the stationery files, so you do not have to select the files and folders every time you run the script.
4D (Fourth Dimension)
- "Products 4D" + "Products 4D.data" is a small 4D database
To use this database you will need 4D Server and the application 4D AppleScript that handles AppleEvents sent to and from 4D Server.
The example scripts "Database List Demo Script", "Database Table Demo Script" and "Database Multi-Page Demo Script" are by default set to use FileMaker Pro or HyperCard. They can be changed to use 4D Server by adding and removing a few comments in the script. Open the Script with Script Editor to find out where to make the changes. Additional information can be found in the file "database_publishing.html".
What about Claris Works?
ClarisWorks 4.0 doesn't support AppleScript access to its database, so it is not possible to publish data from this application using AppleScript.